SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017419 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017419 [ RunTime:0.001499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (233287,992634,579704,111243,44634,930762,487372,703646,731623,385343,604144,630035,342370,671748,701191,776966,412198,820092,1003705,1045608,220398,679529,120053,530730,442059,2169,868235,848904,942069,223301,575016,805802,538887,717313,237692,665442,155975,504385,375713,747075,229616,755308,536877,731398,509431,516319,497814,95423,211348,788029,767151,27044,846087,841337,78038,211181,810859,424724,629835,705911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017419 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017419 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]