SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 954445 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 954445 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022502,408726,386300,560030,759202,716663,1039258,789583,468681,861203,921590,951681,571361,1014048,491376,24534,622600,118056,540316,207732,986044,281314,410634,443059,852425,32851,764521,434296,956215,892202,636550,134192,298056,627977,340372,592918,322972,588479,783300,285870,606398,395664,661559,567384,854506,1041207,485085,839342,889051,354153,304620,834361,644121,73651,537674,620977,801628,357618,846220,501394) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 954445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 954445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]