SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319954 LIMIT 1 [ RunTime:0.001153s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319954 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (708342,900512,653961,194579,780680,117272,241064,779389,382950,941658,952277,290714,845726,491165,374827,548283,1039051,344588,424322,344919,1046629,972542,679051,583209,251685,169535,1023322,276176,227025,298836,738679,353039,566807,830787,662079,615297,735790,709261,733952,765425,410265,750267,639190,645968,366021,1025518,440577,612959,764193,155250,105947,70376,533229,862032,389975,867831,791030,664597,647193,688902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000818s ]